Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 4096 |
| Missing cells | 4096 |
| Missing cells (%) | 7.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 448.1 KiB |
| Average record size in memory | 112.0 B |
Variable types
| Numeric | 10 |
|---|---|
| Categorical | 3 |
| Unsupported | 1 |
SC_NAME has a high cardinality: 4095 distinct values | High cardinality |
SC_CODE is highly overall correlated with SC_GROUP and 1 other fields | High correlation |
OPEN is highly overall correlated with HIGH and 5 other fields | High correlation |
HIGH is highly overall correlated with OPEN and 5 other fields | High correlation |
LOW is highly overall correlated with OPEN and 5 other fields | High correlation |
CLOSE is highly overall correlated with OPEN and 5 other fields | High correlation |
LAST is highly overall correlated with OPEN and 5 other fields | High correlation |
PREVCLOSE is highly overall correlated with OPEN and 5 other fields | High correlation |
NO_TRADES is highly overall correlated with NO_OF_SHRS and 1 other fields | High correlation |
NO_OF_SHRS is highly overall correlated with NO_TRADES and 1 other fields | High correlation |
NET_TURNOV is highly overall correlated with OPEN and 7 other fields | High correlation |
SC_GROUP is highly overall correlated with SC_CODE and 1 other fields | High correlation |
SC_TYPE is highly overall correlated with SC_CODE and 1 other fields | High correlation |
SC_TYPE is highly imbalanced (81.4%) | Imbalance |
TDCLOINDI has 4096 (100.0%) missing values | Missing |
OPEN is highly skewed (γ1 = 21.16748257) | Skewed |
HIGH is highly skewed (γ1 = 21.16760614) | Skewed |
LOW is highly skewed (γ1 = 21.16892196) | Skewed |
CLOSE is highly skewed (γ1 = 21.1686056) | Skewed |
LAST is highly skewed (γ1 = 21.16875173) | Skewed |
PREVCLOSE is highly skewed (γ1 = 21.1341154) | Skewed |
SC_NAME is uniformly distributed | Uniform |
SC_CODE has unique values | Unique |
TDCLOINDI is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2023-06-13 17:11:24.775349 |
|---|---|
| Analysis finished | 2023-06-13 17:11:41.219470 |
| Duration | 16.44 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
SC_CODE
Real number (ℝ)
HIGH CORRELATION UNIQUE
| Distinct | 4096 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 551406.25 |
| Minimum | 500002 |
|---|---|
| Maximum | 974635 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.1 KiB |
Quantile statistics
| Minimum | 500002 |
|---|---|
| 5-th percentile | 500411.75 |
| Q1 | 518015.5 |
| median | 532081 |
| Q3 | 540006.5 |
| 95-th percentile | 890179.25 |
| Maximum | 974635 |
| Range | 474633 |
| Interquartile range (IQR) | 21991 |
Descriptive statistics
| Standard deviation | 95260.776 |
|---|---|
| Coefficient of variation (CV) | 0.17275969 |
| Kurtosis | 11.795543 |
| Mean | 551406.25 |
| Median Absolute Deviation (MAD) | 8878.5 |
| Skewness | 3.6324141 |
| Sum | 2.25856 × 109 |
| Variance | 9.0746154 × 109 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 500002 | 1 | < 0.1% |
| 500003 | 1 | < 0.1% |
| 537292 | 1 | < 0.1% |
| 537326 | 1 | < 0.1% |
| 537392 | 1 | < 0.1% |
| 537483 | 1 | < 0.1% |
| 537524 | 1 | < 0.1% |
| 537536 | 1 | < 0.1% |
| 537573 | 1 | < 0.1% |
| 537707 | 1 | < 0.1% |
| Other values (4086) | 4086 |
| Value | Count | Frequency (%) |
| 500002 | 1 | |
| 500003 | 1 | |
| 500008 | 1 | |
| 500009 | 1 | |
| 500010 | 1 | |
| 500012 | 1 | |
| 500013 | 1 | |
| 500014 | 1 | |
| 500016 | 1 | |
| 500020 | 1 |
| Value | Count | Frequency (%) |
| 974635 | 1 | |
| 974561 | 1 | |
| 974451 | 1 | |
| 974288 | 1 | |
| 974072 | 1 | |
| 973994 | 1 | |
| 973883 | 1 | |
| 973491 | 1 | |
| 972773 | 1 | |
| 972715 | 1 |
SC_NAME
Categorical
HIGH CARDINALITY UNIFORM
| Distinct | 4095 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 32.1 KiB |
| SISL | 2 |
|---|---|
| JMJFIN | 1 |
| NATH BIOGEN | 1 |
| AGRI TECH | 1 |
| CHEMTECH IND | 1 |
| Other values (4090) |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Characters and Unicode
| Total characters | 49152 |
|---|---|
| Distinct characters | 45 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4094 ? |
|---|---|
| Unique (%) | > 99.9% |
Sample
| 1st row | ABB LTD. |
|---|---|
| 2nd row | AEGIS LOGIS |
| 3rd row | AMAR RAJA BA |
| 4th row | A.SARABHAI |
| 5th row | HDFC |
Common Values
| Value | Count | Frequency (%) |
| SISL | 2 | < 0.1% |
| JMJFIN | 1 | < 0.1% |
| NATH BIOGEN | 1 | < 0.1% |
| AGRI TECH | 1 | < 0.1% |
| CHEMTECH IND | 1 | < 0.1% |
| TAAZAINT | 1 | < 0.1% |
| NIF100BEES | 1 | < 0.1% |
| VIAANINDUS | 1 | < 0.1% |
| DENIS CHEM | 1 | < 0.1% |
| POLYMAC | 1 | < 0.1% |
| Other values (4085) | 4085 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| ltd | 129 | 2.1% |
| ind | 87 | 1.4% |
| india | 43 | 0.7% |
| fin | 33 | 0.5% |
| i | 30 | 0.5% |
| indus | 27 | 0.4% |
| cap | 22 | 0.4% |
| tech | 19 | 0.3% |
| in | 15 | 0.2% |
| infra | 15 | 0.2% |
| Other values (4553) | 5649 |
Most occurring characters
| Value | Count | Frequency (%) |
| 13494 | ||
| A | 3689 | 7.5% |
| I | 2848 | 5.8% |
| E | 2593 | 5.3% |
| N | 2413 | 4.9% |
| R | 2256 | 4.6% |
| S | 2157 | 4.4% |
| T | 2093 | 4.3% |
| L | 2065 | 4.2% |
| O | 1726 | 3.5% |
| Other values (35) | 13818 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 33742 | |
| Space Separator | 13494 | 27.5% |
| Decimal Number | 1157 | 2.4% |
| Other Punctuation | 654 | 1.3% |
| Open Punctuation | 47 | 0.1% |
| Close Punctuation | 35 | 0.1% |
| Dash Punctuation | 21 | < 0.1% |
| Lowercase Letter | 2 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 3689 | 10.9% |
| I | 2848 | 8.4% |
| E | 2593 | 7.7% |
| N | 2413 | 7.2% |
| R | 2256 | 6.7% |
| S | 2157 | 6.4% |
| T | 2093 | 6.2% |
| L | 2065 | 6.1% |
| O | 1726 | 5.1% |
| C | 1431 | 4.2% |
| Other values (16) | 10471 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 253 | |
| 0 | 160 | |
| 1 | 131 | |
| 5 | 120 | |
| 9 | 106 | |
| 8 | 97 | 8.4% |
| 3 | 93 | 8.0% |
| 7 | 73 | 6.3% |
| 4 | 73 | 6.3% |
| 6 | 51 | 4.4% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 622 | |
| & | 28 | 4.3% |
| ' | 4 | 0.6% |
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 1 | |
| d | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 13494 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 47 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 35 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 21 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 33744 | |
| Common | 15408 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 3689 | 10.9% |
| I | 2848 | 8.4% |
| E | 2593 | 7.7% |
| N | 2413 | 7.2% |
| R | 2256 | 6.7% |
| S | 2157 | 6.4% |
| T | 2093 | 6.2% |
| L | 2065 | 6.1% |
| O | 1726 | 5.1% |
| C | 1431 | 4.2% |
| Other values (18) | 10473 |
Common
| Value | Count | Frequency (%) |
| 13494 | ||
| . | 622 | 4.0% |
| 2 | 253 | 1.6% |
| 0 | 160 | 1.0% |
| 1 | 131 | 0.9% |
| 5 | 120 | 0.8% |
| 9 | 106 | 0.7% |
| 8 | 97 | 0.6% |
| 3 | 93 | 0.6% |
| 7 | 73 | 0.5% |
| Other values (7) | 259 | 1.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49152 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 13494 | ||
| A | 3689 | 7.5% |
| I | 2848 | 5.8% |
| E | 2593 | 5.3% |
| N | 2413 | 4.9% |
| R | 2256 | 4.6% |
| S | 2157 | 4.4% |
| T | 2093 | 4.3% |
| L | 2065 | 4.2% |
| O | 1726 | 3.5% |
| Other values (35) | 13818 |
SC_GROUP
Categorical
| Distinct | 17 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 32.1 KiB |
| B | |
|---|---|
| X | |
| A | |
| XT | |
| F | |
| Other values (12) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 8192 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | X |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| B | 1146 | |
| X | 1068 | |
| A | 708 | |
| XT | 508 | |
| F | 219 | 5.3% |
| T | 133 | 3.2% |
| M | 121 | 3.0% |
| Z | 98 | 2.4% |
| G | 36 | 0.9% |
| E | 20 | 0.5% |
| Other values (7) | 39 | 1.0% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| b | 1146 | |
| x | 1068 | |
| a | 708 | |
| xt | 508 | |
| f | 219 | 5.3% |
| t | 133 | 3.2% |
| m | 121 | 3.0% |
| z | 98 | 2.4% |
| g | 36 | 0.9% |
| e | 20 | 0.5% |
| Other values (7) | 39 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 3571 | ||
| X | 1576 | |
| B | 1146 | 14.0% |
| A | 708 | 8.6% |
| T | 647 | 7.9% |
| F | 225 | 2.7% |
| M | 131 | 1.6% |
| Z | 99 | 1.2% |
| G | 36 | 0.4% |
| E | 20 | 0.2% |
| Other values (5) | 33 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4621 | |
| Space Separator | 3571 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| X | 1576 | |
| B | 1146 | |
| A | 708 | |
| T | 647 | |
| F | 225 | 4.9% |
| M | 131 | 2.8% |
| Z | 99 | 2.1% |
| G | 36 | 0.8% |
| E | 20 | 0.4% |
| P | 20 | 0.4% |
| Other values (4) | 13 | 0.3% |
Space Separator
| Value | Count | Frequency (%) |
| 3571 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4621 | |
| Common | 3571 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| X | 1576 | |
| B | 1146 | |
| A | 708 | |
| T | 647 | |
| F | 225 | 4.9% |
| M | 131 | 2.8% |
| Z | 99 | 2.1% |
| G | 36 | 0.8% |
| E | 20 | 0.4% |
| P | 20 | 0.4% |
| Other values (4) | 13 | 0.3% |
Common
| Value | Count | Frequency (%) |
| 3571 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8192 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3571 | ||
| X | 1576 | |
| B | 1146 | 14.0% |
| A | 708 | 8.6% |
| T | 647 | 7.9% |
| F | 225 | 2.7% |
| M | 131 | 1.6% |
| Z | 99 | 1.2% |
| G | 36 | 0.4% |
| E | 20 | 0.2% |
| Other values (5) | 33 | 0.4% |
SC_TYPE
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 32.1 KiB |
| Q | |
|---|---|
| D | 170 |
| B | 67 |
| P | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 4096 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Q |
|---|---|
| 2nd row | Q |
| 3rd row | Q |
| 4th row | Q |
| 5th row | Q |
Common Values
| Value | Count | Frequency (%) |
| Q | 3858 | |
| D | 170 | 4.2% |
| B | 67 | 1.6% |
| P | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| q | 3858 | |
| d | 170 | 4.2% |
| b | 67 | 1.6% |
| p | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| Q | 3858 | |
| D | 170 | 4.2% |
| B | 67 | 1.6% |
| P | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4096 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| Q | 3858 | |
| D | 170 | 4.2% |
| B | 67 | 1.6% |
| P | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4096 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| Q | 3858 | |
| D | 170 | 4.2% |
| B | 67 | 1.6% |
| P | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4096 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| Q | 3858 | |
| D | 170 | 4.2% |
| B | 67 | 1.6% |
| P | 1 | < 0.1% |
OPEN
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 3295 |
|---|---|
| Distinct (%) | 80.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2882.0202 |
| Minimum | 0.05 |
|---|---|
| Maximum | 1083851.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.1 KiB |
Quantile statistics
| Minimum | 0.05 |
|---|---|
| 5-th percentile | 2.4325 |
| Q1 | 19.69 |
| median | 79.95 |
| Q3 | 369.825 |
| 95-th percentile | 2002.7625 |
| Maximum | 1083851.2 |
| Range | 1083851.1 |
| Interquartile range (IQR) | 350.135 |
Descriptive statistics
| Standard deviation | 47962.682 |
|---|---|
| Coefficient of variation (CV) | 16.642035 |
| Kurtosis | 452.30459 |
| Mean | 2882.0202 |
| Median Absolute Deviation (MAD) | 73.375 |
| Skewness | 21.167483 |
| Sum | 11804755 |
| Variance | 2.3004188 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 39 | 7 | 0.2% |
| 30 | 6 | 0.1% |
| 25 | 6 | 0.1% |
| 7.15 | 6 | 0.1% |
| 4 | 6 | 0.1% |
| 1000 | 6 | 0.1% |
| 31 | 5 | 0.1% |
| 71 | 5 | 0.1% |
| 2 | 5 | 0.1% |
| 16 | 5 | 0.1% |
| Other values (3285) | 4039 |
| Value | Count | Frequency (%) |
| 0.05 | 1 | |
| 0.22 | 1 | |
| 0.25 | 1 | |
| 0.32 | 1 | |
| 0.34 | 1 | |
| 0.35 | 1 | |
| 0.36 | 1 | |
| 0.38 | 1 | |
| 0.4 | 1 | |
| 0.41 | 2 |
| Value | Count | Frequency (%) |
| 1083851.18 | 1 | |
| 1060000 | 1 | |
| 1059990 | 1 | |
| 1048788.99 | 1 | |
| 1046500 | 1 | |
| 1038500 | 1 | |
| 1020000 | 1 | |
| 1015530.68 | 1 | |
| 762000 | 1 | |
| 199001 | 1 |
HIGH
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 3358 |
|---|---|
| Distinct (%) | 82.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2889.8444 |
| Minimum | 0.05 |
|---|---|
| Maximum | 1083851.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.1 KiB |
Quantile statistics
| Minimum | 0.05 |
|---|---|
| 5-th percentile | 2.4975 |
| Q1 | 20 |
| median | 81.145 |
| Q3 | 376.65 |
| 95-th percentile | 2048.5 |
| Maximum | 1083851.2 |
| Range | 1083851.1 |
| Interquartile range (IQR) | 356.65 |
Descriptive statistics
| Standard deviation | 47985.597 |
|---|---|
| Coefficient of variation (CV) | 16.604907 |
| Kurtosis | 452.32801 |
| Mean | 2889.8444 |
| Median Absolute Deviation (MAD) | 74.665 |
| Skewness | 21.167606 |
| Sum | 11836802 |
| Variance | 2.3026175 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 960 | 6 | 0.1% |
| 28.5 | 6 | 0.1% |
| 105 | 6 | 0.1% |
| 31 | 6 | 0.1% |
| 41 | 6 | 0.1% |
| 965 | 6 | 0.1% |
| 39 | 5 | 0.1% |
| 7.15 | 5 | 0.1% |
| 34.5 | 5 | 0.1% |
| 7.25 | 5 | 0.1% |
| Other values (3348) | 4040 |
| Value | Count | Frequency (%) |
| 0.05 | 1 | < 0.1% |
| 0.23 | 1 | < 0.1% |
| 0.27 | 1 | < 0.1% |
| 0.32 | 1 | < 0.1% |
| 0.35 | 2 | |
| 0.36 | 1 | < 0.1% |
| 0.39 | 1 | < 0.1% |
| 0.41 | 3 | |
| 0.44 | 1 | < 0.1% |
| 0.45 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1083851.18 | 1 | |
| 1063170 | 1 | |
| 1060000 | 1 | |
| 1048788.99 | 1 | |
| 1047500 | 1 | |
| 1038500 | 1 | |
| 1020000 | 1 | |
| 1015530.68 | 1 | |
| 762000 | 1 | |
| 199001 | 1 |
LOW
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 3331 |
|---|---|
| Distinct (%) | 81.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2876.0244 |
| Minimum | 0.05 |
|---|---|
| Maximum | 1083851.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.1 KiB |
Quantile statistics
| Minimum | 0.05 |
|---|---|
| 5-th percentile | 2.3725 |
| Q1 | 19.0975 |
| median | 77.505 |
| Q3 | 362.8125 |
| 95-th percentile | 1997 |
| Maximum | 1083851.2 |
| Range | 1083851.1 |
| Interquartile range (IQR) | 343.715 |
Descriptive statistics
| Standard deviation | 47961.801 |
|---|---|
| Coefficient of variation (CV) | 16.676424 |
| Kurtosis | 452.34839 |
| Mean | 2876.0244 |
| Median Absolute Deviation (MAD) | 71.38 |
| Skewness | 21.168922 |
| Sum | 11780196 |
| Variance | 2.3003343 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 15 | 7 | 0.2% |
| 38 | 6 | 0.1% |
| 960 | 6 | 0.1% |
| 99 | 6 | 0.1% |
| 1 | 6 | 0.1% |
| 19 | 6 | 0.1% |
| 107 | 5 | 0.1% |
| 0.66 | 5 | 0.1% |
| 16 | 5 | 0.1% |
| 3.8 | 5 | 0.1% |
| Other values (3321) | 4039 |
| Value | Count | Frequency (%) |
| 0.05 | 1 | |
| 0.21 | 1 | |
| 0.25 | 1 | |
| 0.31 | 1 | |
| 0.33 | 1 | |
| 0.34 | 1 | |
| 0.35 | 1 | |
| 0.37 | 1 | |
| 0.39 | 1 | |
| 0.4 | 2 |
| Value | Count | Frequency (%) |
| 1083851.18 | 1 | |
| 1060000 | 1 | |
| 1059990 | 1 | |
| 1048788.99 | 1 | |
| 1046500 | 1 | |
| 1038500 | 1 | |
| 1020000 | 1 | |
| 1015530.68 | 1 | |
| 762000 | 1 | |
| 199001 | 1 |
CLOSE
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 3552 |
|---|---|
| Distinct (%) | 86.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2883.5231 |
| Minimum | 0.05 |
|---|---|
| Maximum | 1083851.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.1 KiB |
Quantile statistics
| Minimum | 0.05 |
|---|---|
| 5-th percentile | 2.445 |
| Q1 | 19.55 |
| median | 78.99 |
| Q3 | 370.1 |
| 95-th percentile | 2006.7875 |
| Maximum | 1083851.2 |
| Range | 1083851.1 |
| Interquartile range (IQR) | 350.55 |
Descriptive statistics
| Standard deviation | 47985.103 |
|---|---|
| Coefficient of variation (CV) | 16.641137 |
| Kurtosis | 452.35782 |
| Mean | 2883.5231 |
| Median Absolute Deviation (MAD) | 72.775 |
| Skewness | 21.168606 |
| Sum | 11810911 |
| Variance | 2.3025701 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 960 | 7 | 0.2% |
| 7.15 | 7 | 0.2% |
| 1000 | 6 | 0.1% |
| 0.67 | 6 | 0.1% |
| 1.97 | 5 | 0.1% |
| 965 | 5 | 0.1% |
| 3.9 | 5 | 0.1% |
| 9.88 | 4 | 0.1% |
| 0.66 | 4 | 0.1% |
| 79 | 4 | 0.1% |
| Other values (3542) | 4043 |
| Value | Count | Frequency (%) |
| 0.05 | 1 | |
| 0.23 | 1 | |
| 0.25 | 1 | |
| 0.31 | 1 | |
| 0.33 | 1 | |
| 0.35 | 1 | |
| 0.36 | 1 | |
| 0.38 | 1 | |
| 0.39 | 1 | |
| 0.4 | 2 |
| Value | Count | Frequency (%) |
| 1083851.18 | 1 | |
| 1063170 | 1 | |
| 1060000 | 1 | |
| 1048788.99 | 1 | |
| 1047500 | 1 | |
| 1038500 | 1 | |
| 1020000 | 1 | |
| 1015530.68 | 1 | |
| 762000 | 1 | |
| 199001 | 1 |
LAST
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 3404 |
|---|---|
| Distinct (%) | 83.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2883.486 |
| Minimum | 0.05 |
|---|---|
| Maximum | 1083851.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.1 KiB |
Quantile statistics
| Minimum | 0.05 |
|---|---|
| 5-th percentile | 2.43 |
| Q1 | 19.53 |
| median | 79 |
| Q3 | 370.1625 |
| 95-th percentile | 2011.75 |
| Maximum | 1083851.2 |
| Range | 1083851.1 |
| Interquartile range (IQR) | 350.6325 |
Descriptive statistics
| Standard deviation | 47984.985 |
|---|---|
| Coefficient of variation (CV) | 16.64131 |
| Kurtosis | 452.36233 |
| Mean | 2883.486 |
| Median Absolute Deviation (MAD) | 72.8 |
| Skewness | 21.168752 |
| Sum | 11810759 |
| Variance | 2.3025588 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 960 | 7 | 0.2% |
| 1000 | 7 | 0.2% |
| 0.67 | 7 | 0.2% |
| 7.15 | 6 | 0.1% |
| 965 | 6 | 0.1% |
| 79 | 5 | 0.1% |
| 23 | 5 | 0.1% |
| 985 | 5 | 0.1% |
| 43 | 5 | 0.1% |
| 3.9 | 5 | 0.1% |
| Other values (3394) | 4038 |
| Value | Count | Frequency (%) |
| 0.05 | 1 | < 0.1% |
| 0.23 | 1 | < 0.1% |
| 0.25 | 1 | < 0.1% |
| 0.31 | 1 | < 0.1% |
| 0.33 | 1 | < 0.1% |
| 0.35 | 1 | < 0.1% |
| 0.36 | 1 | < 0.1% |
| 0.39 | 1 | < 0.1% |
| 0.4 | 3 | |
| 0.44 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1083851.18 | 1 | |
| 1063170 | 1 | |
| 1060000 | 1 | |
| 1048788.99 | 1 | |
| 1047500 | 1 | |
| 1038500 | 1 | |
| 1020000 | 1 | |
| 1015530.68 | 1 | |
| 762000 | 1 | |
| 199001 | 1 |
PREVCLOSE
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 3547 |
|---|---|
| Distinct (%) | 86.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2886.8981 |
| Minimum | 0 |
|---|---|
| Maximum | 1088788.8 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.4075 |
| Q1 | 19.5225 |
| median | 78.785 |
| Q3 | 369.775 |
| 95-th percentile | 2006.9625 |
| Maximum | 1088788.8 |
| Range | 1088788.8 |
| Interquartile range (IQR) | 350.2525 |
Descriptive statistics
| Standard deviation | 47932.307 |
|---|---|
| Coefficient of variation (CV) | 16.603394 |
| Kurtosis | 451.22926 |
| Mean | 2886.8981 |
| Median Absolute Deviation (MAD) | 72.535 |
| Skewness | 21.134115 |
| Sum | 11824735 |
| Variance | 2.297506 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 31 | 7 | 0.2% |
| 1000 | 7 | 0.2% |
| 6.05 | 6 | 0.1% |
| 6.99 | 5 | 0.1% |
| 5 | 5 | 0.1% |
| 980 | 5 | 0.1% |
| 0.64 | 4 | 0.1% |
| 13.5 | 4 | 0.1% |
| 3.05 | 4 | 0.1% |
| 19.2 | 4 | 0.1% |
| Other values (3537) | 4045 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 0.05 | 1 | |
| 0.22 | 1 | |
| 0.26 | 1 | |
| 0.32 | 1 | |
| 0.34 | 1 | |
| 0.35 | 1 | |
| 0.36 | 1 | |
| 0.39 | 1 | |
| 0.4 | 1 |
| Value | Count | Frequency (%) |
| 1088788.75 | 1 | |
| 1075000 | 1 | |
| 1045000 | 1 | |
| 1038500 | 1 | |
| 1036000 | 1 | |
| 1033500 | 1 | |
| 1022500 | 1 | |
| 1022228 | 1 | |
| 762000 | 1 | |
| 199000 | 1 |
NO_TRADES
Real number (ℝ)
| Distinct | 1188 |
|---|---|
| Distinct (%) | 29.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 569.45874 |
| Minimum | 1 |
|---|---|
| Maximum | 33184 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 14 |
| median | 72 |
| Q3 | 412 |
| 95-th percentile | 2573.75 |
| Maximum | 33184 |
| Range | 33183 |
| Interquartile range (IQR) | 398 |
Descriptive statistics
| Standard deviation | 1714.4581 |
|---|---|
| Coefficient of variation (CV) | 3.0106802 |
| Kurtosis | 108.77825 |
| Mean | 569.45874 |
| Median Absolute Deviation (MAD) | 69 |
| Skewness | 8.6321884 |
| Sum | 2332503 |
| Variance | 2939366.7 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 222 | 5.4% |
| 2 | 130 | 3.2% |
| 4 | 98 | 2.4% |
| 3 | 97 | 2.4% |
| 5 | 76 | 1.9% |
| 6 | 73 | 1.8% |
| 8 | 54 | 1.3% |
| 10 | 54 | 1.3% |
| 7 | 54 | 1.3% |
| 9 | 51 | 1.2% |
| Other values (1178) | 3187 |
| Value | Count | Frequency (%) |
| 1 | 222 | |
| 2 | 130 | |
| 3 | 97 | |
| 4 | 98 | |
| 5 | 76 | 1.9% |
| 6 | 73 | 1.8% |
| 7 | 54 | 1.3% |
| 8 | 54 | 1.3% |
| 9 | 51 | 1.2% |
| 10 | 54 | 1.3% |
| Value | Count | Frequency (%) |
| 33184 | 1 | |
| 29540 | 1 | |
| 26487 | 1 | |
| 25145 | 1 | |
| 23716 | 1 | |
| 23536 | 1 | |
| 18359 | 1 | |
| 17938 | 1 | |
| 16361 | 1 | |
| 15381 | 1 |
NO_OF_SHRS
Real number (ℝ)
| Distinct | 3292 |
|---|---|
| Distinct (%) | 80.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 103410.23 |
| Minimum | 1 |
|---|---|
| Maximum | 22741092 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 22 |
| Q1 | 799 |
| median | 4601.5 |
| Q3 | 23883.75 |
| 95-th percentile | 295010.75 |
| Maximum | 22741092 |
| Range | 22741091 |
| Interquartile range (IQR) | 23084.75 |
Descriptive statistics
| Standard deviation | 729503.57 |
|---|---|
| Coefficient of variation (CV) | 7.054462 |
| Kurtosis | 437.71194 |
| Mean | 103410.23 |
| Median Absolute Deviation (MAD) | 4488.5 |
| Skewness | 18.508952 |
| Sum | 4.2356832 × 108 |
| Variance | 5.3217546 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 100 | 45 | 1.1% |
| 1 | 45 | 1.1% |
| 10 | 25 | 0.6% |
| 2 | 22 | 0.5% |
| 20 | 18 | 0.4% |
| 30 | 13 | 0.3% |
| 200 | 13 | 0.3% |
| 50 | 13 | 0.3% |
| 4 | 11 | 0.3% |
| 1000 | 10 | 0.2% |
| Other values (3282) | 3881 |
| Value | Count | Frequency (%) |
| 1 | 45 | |
| 2 | 22 | |
| 3 | 9 | 0.2% |
| 4 | 11 | 0.3% |
| 5 | 7 | 0.2% |
| 6 | 7 | 0.2% |
| 7 | 7 | 0.2% |
| 8 | 5 | 0.1% |
| 9 | 8 | 0.2% |
| 10 | 25 |
| Value | Count | Frequency (%) |
| 22741092 | 1 | |
| 17467118 | 1 | |
| 16903226 | 1 | |
| 13915063 | 1 | |
| 10670045 | 1 | |
| 10610614 | 1 | |
| 8625950 | 1 | |
| 6653621 | 1 | |
| 6618267 | 1 | |
| 6108617 | 1 |
NET_TURNOV
Real number (ℝ)
| Distinct | 4059 |
|---|---|
| Distinct (%) | 99.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8329660.2 |
| Minimum | 0 |
|---|---|
| Maximum | 8.8470292 × 108 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1289 |
| Q1 | 46379 |
| median | 345358.5 |
| Q3 | 2837729.8 |
| 95-th percentile | 35577451 |
| Maximum | 8.8470292 × 108 |
| Range | 8.8470292 × 108 |
| Interquartile range (IQR) | 2791350.8 |
Descriptive statistics
| Standard deviation | 37002314 |
|---|---|
| Coefficient of variation (CV) | 4.4422357 |
| Kurtosis | 196.5878 |
| Mean | 8329660.2 |
| Median Absolute Deviation (MAD) | 340955 |
| Skewness | 11.761079 |
| Sum | 3.4118288 × 1010 |
| Variance | 1.3691712 × 1015 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 990 | 3 | 0.1% |
| 13 | 3 | 0.1% |
| 96 | 3 | 0.1% |
| 33 | 3 | 0.1% |
| 28800 | 3 | 0.1% |
| 71523 | 2 | < 0.1% |
| 32637 | 2 | < 0.1% |
| 2235 | 2 | < 0.1% |
| 9108 | 2 | < 0.1% |
| 547 | 2 | < 0.1% |
| Other values (4049) | 4071 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 2 | |
| 5 | 2 | |
| 7 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| 13 | 3 |
| Value | Count | Frequency (%) |
| 884702924 | 1 | |
| 807061674 | 1 | |
| 659846757 | 1 | |
| 510385371 | 1 | |
| 480202286 | 1 | |
| 478258514 | 1 | |
| 449039150 | 1 | |
| 442159023 | 1 | |
| 437944624 | 1 | |
| 351172214 | 1 |
TDCLOINDI
Unsupported
MISSING REJECTED UNSUPPORTED
| Missing | 4096 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 32.1 KiB |
| SC_CODE | OPEN | HIGH | LOW | CLOSE | LAST | PREVCLOSE | NO_TRADES | NO_OF_SHRS | NET_TURNOV | SC_GROUP | SC_TYPE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SC_CODE | 1.000 | 0.118 | 0.118 | 0.118 | 0.118 | 0.118 | 0.116 | -0.133 | -0.071 | -0.013 | 0.700 | 0.904 |
| OPEN | 0.118 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.999 | 0.295 | -0.164 | 0.511 | 0.110 | 0.149 |
| HIGH | 0.118 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.999 | 0.297 | -0.161 | 0.513 | 0.110 | 0.149 |
| LOW | 0.118 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.999 | 0.294 | -0.164 | 0.511 | 0.110 | 0.149 |
| CLOSE | 0.118 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.999 | 0.296 | -0.163 | 0.512 | 0.110 | 0.149 |
| LAST | 0.118 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.999 | 0.296 | -0.163 | 0.512 | 0.110 | 0.149 |
| PREVCLOSE | 0.116 | 0.999 | 0.999 | 0.999 | 0.999 | 0.999 | 1.000 | 0.296 | -0.163 | 0.512 | 0.110 | 0.149 |
| NO_TRADES | -0.133 | 0.295 | 0.297 | 0.294 | 0.296 | 0.296 | 0.296 | 1.000 | 0.770 | 0.879 | 0.112 | 0.000 |
| NO_OF_SHRS | -0.071 | -0.164 | -0.161 | -0.164 | -0.163 | -0.163 | -0.163 | 0.770 | 1.000 | 0.726 | 0.000 | 0.000 |
| NET_TURNOV | -0.013 | 0.511 | 0.513 | 0.511 | 0.512 | 0.512 | 0.512 | 0.879 | 0.726 | 1.000 | 0.096 | 0.000 |
| SC_GROUP | 0.700 | 0.110 | 0.110 | 0.110 | 0.110 | 0.110 | 0.110 | 0.112 | 0.000 | 0.096 | 1.000 | 0.678 |
| SC_TYPE | 0.904 | 0.149 | 0.149 | 0.149 | 0.149 | 0.149 | 0.149 | 0.000 | 0.000 | 0.000 | 0.678 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| SC_CODE | SC_NAME | SC_GROUP | SC_TYPE | OPEN | HIGH | LOW | CLOSE | LAST | PREVCLOSE | NO_TRADES | NO_OF_SHRS | NET_TURNOV | TDCLOINDI | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 500002 | ABB LTD. | A | Q | 3936.05 | 3937.80 | 3842.75 | 3852.35 | 3852.35 | 3942.65 | 2025 | 10483 | 40728178 | NaN |
| 1 | 500003 | AEGIS LOGIS | A | Q | 371.05 | 379.50 | 360.05 | 363.80 | 363.80 | 378.00 | 5331 | 97006 | 35553207 | NaN |
| 2 | 500008 | AMAR RAJA BA | A | Q | 626.00 | 632.05 | 622.60 | 624.10 | 623.65 | 626.05 | 659 | 8778 | 5505116 | NaN |
| 3 | 500009 | A.SARABHAI | X | Q | 22.89 | 22.89 | 22.12 | 22.26 | 22.26 | 22.46 | 176 | 84680 | 1888208 | NaN |
| 4 | 500010 | HDFC | A | Q | 2787.95 | 2795.75 | 2773.00 | 2784.05 | 2784.05 | 2776.50 | 3333 | 29724 | 82883348 | NaN |
| 5 | 500012 | ANDHRA PETRO | X | Q | 63.21 | 64.18 | 62.70 | 62.90 | 62.90 | 63.62 | 497 | 53082 | 3352532 | NaN |
| 6 | 500013 | ANSAL INFRAS | T | Q | 9.90 | 9.90 | 9.51 | 9.70 | 9.70 | 9.69 | 41 | 10187 | 98623 | NaN |
| 7 | 500014 | UTIQUE | X | Q | 5.52 | 5.60 | 5.30 | 5.52 | 5.50 | 5.25 | 197 | 105306 | 578015 | NaN |
| 8 | 500016 | ARUNAHTEL | XT | Q | 19.30 | 21.27 | 19.30 | 19.89 | 19.80 | 20.26 | 116 | 33203 | 685987 | NaN |
| 9 | 500020 | BOM DYEING | B | Q | 83.60 | 87.50 | 83.35 | 86.35 | 85.85 | 83.67 | 1536 | 191507 | 16399249 | NaN |
| SC_CODE | SC_NAME | SC_GROUP | SC_TYPE | OPEN | HIGH | LOW | CLOSE | LAST | PREVCLOSE | NO_TRADES | NO_OF_SHRS | NET_TURNOV | TDCLOINDI | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4086 | 972715 | IFCI150212C | F | B | 12800.00 | 12800.00 | 12800.00 | 12800.00 | 12800.00 | 12800.00 | 1 | 3 | 38400 | NaN |
| 4087 | 972773 | 990IFCI37D | F | B | 25500.00 | 25500.00 | 25500.00 | 25500.00 | 25500.00 | 25500.00 | 3 | 12 | 306000 | NaN |
| 4088 | 973491 | 675PCHFL31 | F | B | 795.00 | 797.00 | 794.00 | 796.21 | 796.21 | 796.53 | 13 | 1572 | 1249711 | NaN |
| 4089 | 973883 | 970UPCL32 | F | B | 1059990.00 | 1063170.00 | 1059990.00 | 1063170.00 | 1063170.00 | 1036000.00 | 2 | 2 | 2123160 | NaN |
| 4090 | 973994 | 962APSBCL31 | F | B | 1020000.00 | 1020000.00 | 1020000.00 | 1020000.00 | 1020000.00 | 1022228.00 | 1 | 1 | 1020000 | NaN |
| 4091 | 974072 | 8HDFCL32 | F | B | 1083851.18 | 1083851.18 | 1083851.18 | 1083851.18 | 1083851.18 | 1088788.75 | 1 | 2 | 2167702 | NaN |
| 4092 | 974288 | 995UPPCL32 | F | B | 1060000.00 | 1060000.00 | 1060000.00 | 1060000.00 | 1060000.00 | 1075000.00 | 1 | 1 | 1060000 | NaN |
| 4093 | 974451 | 962APSB31 | F | B | 1015530.68 | 1015530.68 | 1015530.68 | 1015530.68 | 1015530.68 | 1022500.00 | 1 | 2 | 2031061 | NaN |
| 4094 | 974561 | 11MML26 | F | B | 101685.00 | 101750.00 | 101685.00 | 101728.33 | 101715.00 | 101650.00 | 6 | 7 | 712055 | NaN |
| 4095 | 974635 | 0EEL26 | F | B | 102080.00 | 102080.00 | 102080.00 | 102080.00 | 102080.00 | 102176.20 | 1 | 1 | 102080 | NaN |